/*
 * Copyright 2015 The Dudu Project
 *
 * The Dudu Project licenses this file to you under the Apache License,
 * version 2.0 (the "License"); you may not use this file except in compliance
 * with the License. You may obtain a copy of the License at:
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
 * License for the specific language governing permissions and limitations
 * under the License.
 */
package dudu.service.dao;

import java.util.Date;
import java.util.List;

import dudu.service.dao.bean.LocationBean;

public class LocationDao extends DuduDaoSupport {

	public LocationDao() {
		
	}
	
	public List<LocationBean> get(String sensorId, Date startTime, Date endTime)
		throws DaoException {
		
		String locIdStart = sensorId + "#" + startTime.getTime();
		String locIdEnd = sensorId + "#" + endTime.getTime();
		
		String hql = String.format("FROM LocationBean lb WHERE " + 
			"lb.locId BETWEEN \'%s\' AND \'%s\'", 
			locIdStart,
			locIdEnd);
		
		return super.query(hql);
	}
}
